/*    */ package com.yc.dao.export;
/*    */ 
/*    */ import btsm.bean.dbConnector;
/*    */ import com.yc.dao.model.TransformerBO;
/*    */ import com.yc.util.FormateSQL;
/*    */ import java.sql.ResultSet;
/*    */ import java.util.ArrayList;
/*    */ import java.util.List;
/*    */ import org.apache.commons.logging.Log;
/*    */ import org.apache.commons.logging.LogFactory;
/*    */ 
/*    */ public class TransformerExportDAO
/*    */   implements IExportAll
/*    */ {
/* 18 */   private static final Log log = LogFactory.getLog(TransformerExportDAO.class);
/*    */ 
/* 20 */   public List export(dbConnector dbcon, String strBtsName, String strRegistBeginTime, String strRegistEndTime) { ResultSet rs = null;
/* 21 */     List list = new ArrayList();
/*    */     try
/*    */     {
/* 24 */       String strSQL = " select * from transformer where btsname like '%" + strBtsName + "%'  ";
/* 25 */       strSQL = FormateSQL.getFormateSQL(strRegistBeginTime, strRegistEndTime, strSQL);
/* 26 */       log.info(strSQL);
/* 27 */       rs = dbcon.execQuery(strSQL);
/* 28 */       while (rs.next()) {
/* 29 */         TransformerBO bo = new TransformerBO();
/* 30 */         bo.setId(rs.getString("id"));
/* 31 */         bo.setBtscode(rs.getString("btscode"));
/* 32 */         bo.setBtsname(rs.getString("btsname"));
/* 33 */         bo.setModel(rs.getString("model"));
/* 34 */         bo.setCapacity(rs.getString("capacity"));
/* 35 */         bo.setManufacturer(rs.getString("manufacturer"));
/* 36 */         bo.setProperty(rs.getString("property"));
/* 37 */         bo.setMaintenance(rs.getString("maintenance"));
/* 38 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 39 */         bo.setMemo(rs.getString("memo"));
/* 40 */         bo.setTranPowerType(rs.getString("tranPowerType"));
/* 41 */         bo.setTranMaintain(rs.getString("tranMaintain"));
/* 42 */         bo.setTranHighLen(rs.getString("tranHighLen"));
/* 43 */         bo.setTranLowLen(rs.getString("tranLowLen"));
/* 44 */         bo.setTranRValue(rs.getString("tranRValue"));
/* 45 */         bo.setTranStartTime(rs.getString("tranStartTime"));
/* 46 */         list.add(bo);
/*    */       }
/*    */     }
/*    */     catch (Exception e) {
/* 50 */       e.printStackTrace();
/* 51 */       log.error(e.getMessage());
/*    */     }
/* 53 */     return list;
/*    */   }
/*    */ }

/* Location:           E:\java\apache-tomcat-6.0.36\webapps\btsm\WEB-INF\classes\
 * Qualified Name:     com.yc.dao.export.TransformerExportDAO
 * JD-Core Version:    0.6.2
 */